Re: Postgresql & ODBC

At 7:53 -0800 2003/01/30, Art Fore wrote:
>I went through the info on the documentation to setup ODBC for
>Postgresql, but when I use isql PostgresQL-test, I get a no connect
>error. Could someone tell me what I did wrong? The two ini files are
>below. I can connect with Rekall, but it does not use ODBC, it uses
>python script.
>
>odbc.ini
>
>[PostgreSQL]
>Description         = Test to Postgres
>Driver              = PostgreSQL
>Trace               = Yes
>TraceFile           = sql.log
>Database            = test
>Servername          = localhost
>UserName            =
>Password            =
>Port                = 5432
>Protocol            = 6.4
>ReadOnly            = No
>RowVersioning       = No
>ShowSystemTables    = No
>ShowOidColumn       = No
>FakeOidIndex        = No
>ConnSettings        =
>
>odbcinst.ini
>
>[PostgreSQL]
>Description    = PostgreSQL driver
>Driver    = /usr/lib/unixODBC/libodbcpsql.so
>Setup    = /usr/lib/unixODBC/libodbcpsqlS.so
>FileUsage    = 1
>

I do not know isql, but your odbc.ini does not contain the list of
datasources and the definition of the PostgresQL-test datasource
itself.

Giuliano